TABLE ACCESS BY INDEX ROWID
Short Description
Rows are located using index(es).
Detailed Description​
Rows are being retrieved from the table by ROWID after the IDs have been obtained from a supporting index. ROWIDs are used by Oracle to represent a physical location on disc and are the quickest way to access single blocks.
Further Reading​
- Oracle Magazine - How to read an execution plan
- Oracle Tuning Guide - Explaining and Displaying Execution Plans
- Oracle Tuning Guide - Comparing Execution Plans Tutorial
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.